Connecting to your Google SQL data warehouse requires a few simple steps to get you started.
1. Create a Google Cloud MySQL Database
2. Configure Google Cloud MySQL in Toric
3. Connect to External Warehouse
Before you configure Google Cloud SQL in Toric, you will need to create a Google Cloud MySQL database.
Login to Toric and follow these steps to setup a new warehouse connector:
Type a unique name for your Google SQL connector.
There are four (4) mandatory fields that require information about your Google SQL database.
First, you will need to enter your Host name.
Note: If this information is incorrect, you will get an invalid configuration warning.
Then, enter the Port number associated to your Google MySQL database.
Next, enter your Google MySQL database name, username, and password.
Use the Validate Configuration button to make sure all fields are completed correctly. Invalid fields will be highlighted in red, and a successful validation will show with a green check mark.
Click on Add Configuration to finalize the creation of your Microsoft SQL Connector.
Navigate to the Data Warehouses section to create a New Connected Warehouse.
In the pop-up, enter a Warehouse Name.
Note: We recommend using a unique name as you can create multiple warehouse connections.
Use the Application dropdown to select a data warehouse provider, in this case Google Cloud SQL (MySQL). Then use the Configuration dropdown to select one of the options from step 2.1.
Finally, use the Table dropdown to select where to write your data.