During this post we will discuss about how to use third party packages from anaconda in Snowflake. As we know Anaconda Announces Partnership with Snowflake to Bring Open-Source Python to the Data Cloud. Hence, Now onwards a number of popular open source third-party Python packages that are built and provided […]
Read More
During this post we will discuss about Transferring Pipe Ownership. In our current Account majority of PIPES are owned by ACCOUNTADMIN role. As part of maintenance, this becomes a painful task for AccountAdmin role. As per discussion with Business, it was decided to transfer some responsibility from ADMIN to other […]
Read More
During this post we will discuss a requirement which we resolve using SQL scripting. Currently we are in the development phase, and we have created multiple tables. Later on, using the different mechanisms we have populated these tables. As per the confirmation from the source team as well, they don’t […]
Read More
During this post we will discuss about Primary roles and Secondary Roles. Primary Role is your current role. The Role we select by using USE <<ROLE>> or the default role assigned to the user at the time of creation. Sometimes when there is no role assign a default PUBLIC role […]
Read More
During the last post we discussed DIRECTORY table and GET_PRESIGNED_URL two key properties in snowflake. We used these features to download the File Snowflake WEBUI instead of respective cloud provider UI framework. We accessed the file present on the external stage i.e. AWS using DIRECTORY and GET_PRESIGNED_URL in SQL query. […]
Read More
ADF Script Activity: During the last ADF post we have discussed about COPY activity to ingest data into snowflake. With COPY Activity we have limited control in terms of loading data from external stage to Snowflake. Also there are key Snowflake COPY parameters and we cannot leverage them during ADF […]
Read More
