Recent questions tagged SNOWFLAKE

0 votes

1.4k views

1 answer

snowflake cloud data platform - Terraform: "Variables may not be used here" during terraform init

I am using Terraform snowflake plugins. I want to use ${terraform.workspace} variable in terraform scope. ... terraform-variables-may-not-be-used-here-during-terraform-init...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

766 views

1 answer

snowflake cloud data platform - Tri-Secret benefits

I am wondering what the functional benefits are of applying Tri-Secret Managed Key security in Snowflake ... https://stackoverflow.com/questions/65889825/tri-secret-benefits...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

snowflake cloud data platform - Max LOB size (16777216) exceeded for array_agg

I have a table with about 30k rows and each of them is put in {} in the end I would like to ... /stackoverflow.com/questions/65901325/max-lob-size-16777216-exceeded-for-array-agg...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

922 views

1 answer

snowflake cloud data platform - SnowPipe Paused ( NULL result in a non-nullable colum )

I have set up snow pipe and it reads from S3 (JSON File) and for some reason it has paused suddenly, ... com/questions/65907140/snowpipe-paused-null-result-in-a-non-nullable-colum...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

snowflake cloud data platform - got error 253006 (n/a): File doesn't exist: when used PUT command in windows

when tried to upload to file to snowflake cloud from local by using PUT command in windows command line. I tried ... -n-a-file-doesnt-exist-when-used-put-command-in-windows...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

844 views

1 answer

snowflake cloud data platform - filter a table on a cluster key efficiently

I have a snowflake table, with a clustering key with the format yyyy-mm-dd-hh, and I would like to filter ... .com/questions/65937717/filter-a-table-on-a-cluster-key-efficiently...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

855 views

1 answer

snowflake cloud data platform - Is there a function in SQL that automatically generates more rows by month?

I've got a large database that's got all our transactions and shipping costs from them, here's a simplified ... -a-function-in-sql-that-automatically-generates-more-rows-by-month...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

835 views

1 answer

snowflake cloud data platform - How to stop any sql by ACCOUNTADMIN

Even a user with the ACCOUNTADMIN role cannot view the results for a query run by another user. How can ... .com/questions/66061852/how-to-stop-any-sql-by-accountadmin...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

935 views

1 answer

snowflake cloud data platform - Get top 3 IDs with highest amount using window calculation in matillion etl

I have a table that looks like this: id | name | amount 1 jesse 192$ 2 sam 123$ 3 steve 345$ 4 josh 234$ 5 hamish ... want the result to look like id amount 5 452$ 3 345$ 9 311$...

asked Jan 29, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

snowflake cloud data platform - Calling procedure through Snowsql

i am calling strored procedure thorugh SNOWSQL and getting below error. 002141 (42601): SQL compilation error: Unknown user- ... let me know if anything is wrong here. Thanks....

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

snowflake schema - Future data is not yet available for table error when running Create or replace table CLONE

Recently, in the last few days, we're having lot's of errors about "Future data is not yet available for table " when ... what is it referring to and how can we avoid it? Thanks!...

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

snowflake cloud data platform - SQL query to find ids in the same table but different timestamp events (cohorts)

I need to write a query that gives me the count with the following logic. The example below shows that ACCOUNT_ID 123 signup ... :timestamp_ntz ) < CURRENT_DATE()) ) GROUP BY 1,2 )...

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags