Відео

If I understand your question correctly, you would like to see the hidden character in Excel. This might be helpful. support.microsoft.com/en-us/office/hide-or-display-cell-values-c94b3493-7762-4a53-8461-fb5cd9f05c33

dashboardsexcel.com/blogs/blog/excel-tutorial-remove-hidden-characters

QUERY_HISTORY View can be used to query Snowflake query history by various dimensions (time range, session, user, warehouse, etc.) within the last 365 days (1 year).

Select * from Snowflake.Account_usage.query_history

If you cannot see this view (Snowflake.Account_Usage.Query_history), it means you are not given proper privilege

I don't have anything for that at this moment. Thanks

Not sure which script you are interested in. This is the one that all other scripts are based on. The warehouse_metering_history is the system view you need to use. select warehouse_name, sum(credits_used) as credits_used from snowflake.account_usage.warehouse_metering_history wmh group by warehouse_name order by 2 desc;

Another example: SELECT WAREHOUSE_NAME ,SUM(CREDITS_USED_COMPUTE) AS CREDITS_USED_COMPUTE_SUM ,'Shows the total credit consumption for each warehouse over a specific time period (past 7 days)' AS Comments FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY WHERE START_TIME >= DATEADD(DAY, -7, CURRENT_TIMESTAMP()) // Past 7 days GROUP BY 1 ORDER BY 2 DESC ;

Thank you for the feedback. This is the link to CSV Lint. Hope it is useful to someone: github.com/BdR76/CSVLint

The copy command can be found in Snowflake Documentation. docs.snowflake.com/en/sql-reference/sql/copy-into-location. There is no troubleshooting code for Azure SAS Token. You need to go to Azure portal, locate the blob storage, recreate SAS token, then use this new token in your Snowflake stage. feel free to ask more questions.

Hi When I'm trying to move data from Snowflake to ASQl using Blob as stage layer, getting error as below: Fail to access remote file: access denied. Please check your credentials

Yes, I think you can.

If you have any questions, I am happy to answer them.

@@SnowflakePro What is the change in the OPENQUERY SELECT statement for linking to an EXCEL file that is different than the normal SQL Server SELECT statement.

@@lindaitken3321 You need to install x64 access database engine

@@SnowflakePro So the SELECT statement is the same as for a T-SQL query?

@@lindaitken3321 Yes

This tells you how to build a robust SSIS process without breaking the control flow using Snowflake. It would help you understand it if you are familiar with SSIS. Thank you for the inquiry.

@@SnowflakePro But you did not show how to setup the ODBC Connection Manager, right?

@@sreesweraam Check my other video for details