New answers tagged

1

You need in something like SELECT *, CASE WHEN COUNT(CASE WHEN sts = 'Enabled' THEN 1 END) OVER (PARTITION BY acctid) > 0 THEN 'Active' WHEN COUNT(CASE WHEN sts IS NOT NULL THEN 1 END) OVER (PARTITION BY acctid) > 0 THEN 'Cancelled' ELSE 'Unknown' END Status FROM usr fiddle


0

Running SHOW PARAMETERS LIKE 'TIMEZONE'; returns in my case: key value default TIMEZONE America/Los_Angeles America/Los_Angeles SELECT CURRENT_TIMESTAMP() results in 2019-11-04 07:48:47.289 -0800. Then I can alter the session parameter like this ALTER SESSION SET TIMEZONE = 'Europe/Amsterdam'; Now SHOW PARAMETERS ...


1

Yes, there are a few: Matillion https://snowflake-support.matillion.com/s/article/2834120 Stichdata you have to reach out to sales https://www.stitchdata.com/contact/ Alooma looks like it may limit enterprise versions https://www.alooma.com/docs/connect-your-data/common-integration-settings/advanced-connectivity AWS Direct Connect and AWSPrivatelink https://...


Top 50 recent answers are included