Once our Snowflake Account is properly prepared, we'll connect it to Databox. This new Network Policy will now appear in the main window, and remote access from Databox is set up. Click the drop-down arrow in the upper right corner of the Account and Switch Role to "ACCOUNTADMIN"Ĭlick on Account > Policies and select Create to create a new Network PolicyĮnter "DATABOX" as the Name and Databox's public IP (52.4.198.118) in the Allowed IP Addresses field The database is now set up, data is loaded and the warehouse is ready to go.įinally, we need to add the Databox IP to the Snowflake Account so queries can be run from Databox. We've prepared a CSV file with the following content:Ĭlick Load Table and choose the warehouse we created earlierĬlick Next and choose the appropriate CSV file.
This warehouse will now appear in our list. We'll name this new warehouse "WAREHOUSE_X_SMALL." We've selected X-Small as the Size, 5 minutes as the Auto Suspend time, and we checked the Auto Resume checkbox.Ĭlick Finish to save the new warehouse. Next, we'll click on the Warehouses icon and will select Create to create a new warehouse We'll create a simple table with 3 columns for our example, and will name it "SAMPLE_DATA" To do this, we'll click on the database name and will select Schemas > Create Next, we'll create a schema for our database. Learn more about Snowflake security best practices here.
Roles can be changed in the upper right corner of Snowflake.
0 kommentar(er)
