I’ve got a Snowflake SQL query I’m trying to execute in R via ODBC connection that looks like this Querying Microsoft SQL Server from R I’d normally include set nocount no; at the top of the query to ensure only the last step is returned to R to avoid the error Actual statement count 6 did n…
Tag: snowflake-task
Snowflake to S3 with Header
Does anyone know of a way to export your data from Snowflake to an S3 file with a header? For example, I have this table: I want to export this data to a file that looks like this: … but I don’t see an option in the Snowflake documentation to do so. I tried a simple UNION ALL with the
Flatten data source in Snowflake from Array
I am trying to fix an array in a dataset. Currently, I have a data set that has a reference number to multiple different uuids. What I would like to do is flatten this out in Snowflake to make it so the reference number has separate row for each uuid. For example Should end up looking like: I just started