...
Select Platform Settings in the side bar
In the pop-out side panel, under Integrations click on Sources
Click Add Source and select Snowflake SQL Server
Select Direct Connect and add your Snowflake SQL Server details and click Next
Fill in the Source Settings and click Next
Name: The name you wish to give your SQL Server
Host: Add the server location for the SQL Server instance
Version number: Set the SQL Server version
Extract Meta Only: Set this if extended events is not enabled
Add the Connection details and click Save & Next when connection is successful
Host: Add the SQL Server location
Username: Add the SQL Server User created in Step 1
Password: Add the User password created in Step 1
Test your connection and click Save
Return to the Sources page and locate the new SQL Server source that you created
Click on the clock icon to select Edit Schedule and set your preferred schedule for the SQL Server load
| Info |
|---|
Note that scheduling a source can take up to 15 minutes to propagate the change. |
...
Step 3) Manually run an ad hoc load to test
...
SQL Server setup
Next to your new Source, click on the Run manual load icon
Confirm how you want the source to be loaded
After the source load is triggered, a pop up bar will appear taking you to the Monitor tab in the Batch Manager page. This is the usual page you visit to view the progress of source loads
| Info |
|---|
A manual source load will also require a manual run of
To load all metrics and indexes with the manually loaded metadata. These can be found in the Batch Manager page |
...