Dawid
- Total activity 181
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 6
- Subscriptions 54
-
Dawid created a post, Support for syntax highlighting - Snowflake - "AS" in PIVOT column rename
Snowflake allows us to change the column name inside the PIVOT -
Dawid created a post, Support for syntax highlighting of TRANSFORM in Snowflake
This is a function that allows to modify arrays with lambda expression: https://docs.snowflake.com/en/sql-reference/functions/transform -
Dawid created a post, Snowflake - Syntax error for a correct query
This code actually errors out in DataGrip but it's syntactically correctWITH test_cte AS ( SELECT 1 AS test UNION DISTINCT SELECT 2 ) SELECT * FROM test_cte ; -
-
Dawid created a post, -
Dawid created a post, AnsweredAllow to delete a console while it's opened
Keeping the consoles/files tidy is quite a maintenance task on its own. I would like to be able to permanently delete the console I've just used but I can't find this option when I right click on t... -
-
-
Dawid created a post, Redshift Serverless - Creating masking policies
I am trying to execute this code:CREATE MASKING POLICY mask_ssnWITH (ssn VARCHAR(11))USING (LEFT(ssn, 7) || '00'); And I'm not sure if Datagrip does something to it but it's rejected every time and... -
Dawid commented,