How can I connect to a Snowflake database via JDBC using the "database" command in MATLAB R2022b?

I am attempting to connect to a Snowflake database via JDBC using the "database" command. I am unclear on the correct syntax for the arguments to this command, as Snowflake is specific regarding parameters and URL formatting. 

Answer 1

[MathWorks Support Team]

Refer to the following for an example MATLAB command to connect to a Snowflake database via JDBC using the "database" function: 

>> conn = database('','<username>','<password>’,'net.snowflake.client.jdbc.SnowflakeDriver','jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?db=<dbname>;') 

Note the following:

• The database name is passed in as a parameter in the URL, rather than in the first argument or a name-value pair argument.
• Parameters are included in the URL, rather than in name-value pair arguments.
• The account identifier is the same as described in the Snowflake documentation: 

https://docs.snowflake.com/en/user-guide/jdbc-configure.html#jdbc-driver-connection-string 

• If you have additional access restrictions such as a region or PrivateLink, they can be included with the account identifier. For example, "myorg.myregion.privatelink.snowflakecomputing.com".