Specify sql variable in dbt

dbt

Solution 1:

If this is in SQL Server, isn't the syntax @@RowCount?

Pre-supposing that, there are two in development dbt "Adapter" projects to SQL Server:

Per the docs on supported dbs:

  • dbt-sqlserver - SQL Server 2016 and later
  • dbt-mssql - SQL Server 2008 R2 and later

Depending on your version, I would recommend opening an issue for that particular variable if it doesn't work as-is.

Related

Add IDs to dataframe with random Noise
How do you validate an IP address on Android?
Most pythonic+computationally efficient way to check if each element in 2D array A is in any of the single arrays in 2D array B, and save the results
Detect enter key pressed python
How does all() in python work on empty lists
data.table::fwrite behaving strange when saving file names
regex javascript to match both RGB and RGBA
PHP Warning: Division by zero rankplayer.php [duplicate]
Disable row selection in mvc and Enable column selection in mvc kendo grid
Near protocol equivalent of buring NEAR tokens by sending to address(0)
regexp for checking the full name
builtin_function_or_method' object has no attribute shuffle