I’m trying to load data into a table and data is coming from a sp which we are calling inside the main sp and loading data it into the table.
I have sql code which is working completely fine and i try to convert the below SQL script into snowflake but not snowflake code is not working as expected.

I am running copy jobs from snowflake tables to S3, and few of the tables are empty. Is there a way to generate an empty parquet file for these tables?

Target Column Length VARCHAR(16777216). String “Financial Services.Fees.Regulatory, Agencies, State” is too long and would be truncated.

I am trying to get a result set with 2 columns from snowflake using dynamic SQL, this is read from the INFORMATION_SCHEMA_TABLES metadata.

Need to group records from following below sample input data on based on state,card number,card type, origin, method of payment, sales amount so that all records belonging to same group will be present in single row.

{ “explosives_UG”:{ “isCritical”: false, “value”: “N/A” }, “explosivesUG”: { “comment”: “Test 619 313”, “createWo”: false, “isCritical”: false, “value”: “No” }, “generalAttachment”: null, “generalComment”: “Test 619 313”, “guardsPostedUG”: { “isCritical”: false, “value”: “Yes” }, “imminentUG”: { “isCritical”: false, “value”: “Yes” } } using the above JSON format, output is generated as below via Snowflake query question […]

{ “area”: { “id”: “TEST1” “value”: “TEST1” }, { “testcom”: { “conditions”: [ { “assignedto”: { “workphone”:NULL }, “isClause”:false } ], “iscritical”: true, “value”: “Conditon” } } } Hi, the output of json structure is as above questions answer isClause testcom conditions FALSE Need the output as above, i have used the below SQL, not […]

We have a use case where user will provide starttime, endtime, and Interval as parameters. and we need to pass these parameters to view logic where we have business logic, But the Interval function is not accepting any parameters. Please help how to pass parameter to add interval. below is a simple example.

My requirement is-
Fetch the count of a table, size of a table 7days ago.

in snowlake.account_usage.access_history DIRECT_OBJECTS_ACCESSED and BASE_OBJECTS_ACCESSED contains the objects that were involved in the query