snowflake-cloud-data-platform
pandas converting EXCEL date '1/0/1900' to ' 00:00:00'
I have this excel file that is being read by pandas into a dataframe , then output the dataframe contents to snowflake table.[详细]
2022-12-07 21:46 分类:问答DBT : For loop for 2 variable simultaneously
My Sample code is : {%-set VARIABLE = ["123","1234"]-%} {%-set VARIABLE1 = ["abc","def"]-%}[详细]
2022-12-07 20:41 分类:问答Snowflake auto converts list of floats to json string
Some of my data in snowflake is in json str format, but in actual it is list of floats. I used an udf to convert json str to list of floats but seems like snowflake is internally auto converting list[详细]
2022-12-07 19:12 分类:问答write multipe statments in snowflake
Hi i have one doubt in snowflake how to write multiple update stments using stored procedure. i have tried like below[详细]
2022-12-07 18:44 分类:问答Is there a way to have custom SQL query on top of JPA repository to have BULK UPSERTS?
I have a snowflake database and it doesn\'t support unique constraint enforcement (https://docs.snowflake.com/en/sql-reference/c开发者_StackOverflowonstraints-overview.html).[详细]
2022-12-07 17:38 分类:问答