Eric Muijs
Eric Muijs
Could it be related to SELECT *? Potentially the materialization adds additional columns. Nvarchars are also not supported if you use those. Look into log folder and run the commands...
I like the suggestion of starting with the dbt fabric adapter, and use as a parent but how does that work in code? Do we copy the fabric code (a...
Might not be related to dbt?: https://stackoverflow.com/questions/12063850/multiple-timestamp-columns-in-sql-server-2000 Cast to datetime2 datatypes in the view might help solve the issues.
timestamp is some internal database type that tracks changes on a table. Basically it is not "data" but more metadata on the table by the sql server engine. It is...
Option: you could also do: CONCAT('', field_list)
See this pull request: https://github.com/dbt-msft/dbt-sqlserver/pull/461 You need to attach a maintainer which can trigger the tests. However, in the current state, it is best to wait until the pull request...
I don't think I can help with this, but there are conflicts that have to be resolved first (GitHub message).
@astocks : im not a maintainer I think. I'm not able to start the tests. Reach out to one of the maintainers.
I found the issue in snapshot.sql ``` {% set tempTable %} SELECT * INTO {{tempTableName}} {{columns}} FROM [{{relation.database}}].[{{ relation.schema }}].[{{ relation.identifier }}] {{ information_schema_hints() }} {% endset %} ``` Columns...
https://github.com/dbt-msft/dbt-sqlserver/pull/477