Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options questions only user 159945

Snowflake is a cloud-based data warehouse

0
votes
1answer
people have done in the past or hear other solutions that people would be willing to suggest. Are there any ETL tools that support VPN connections? Source database: postgres Target database: Snowflake
asked Mar 13 by ajputnam
1
vote
1answer
I am having difficultly finding documentation on how to insert data into an ARRAY column type using SQL on a Snowflake table. Snowflake Documentation: https://docs.snowflake.net/manuals/sql … , '[1,2,3]' ); I have tried using using postgres's syntax like ones described here: https://stackoverflow.com/questions/33335338/inserting-array-values I originally asked this question here: Snowflake Community …
asked Sep 13 '18 by ajputnam
3
votes
1answer
I have several tables in Postgres that we are migrating to Snowflake. Some of these table are hierarchical (a foreign key point to the same table), normally to query this data I use CTE tables and/or … recursive SQL statements. As far as I can tell Snowflake does not support these operations. Are there any other queries that can be made to mimic this or work around this? "Currently, Snowflake
asked Sep 11 '18 by ajputnam