While saving a data source in Information Designer, the "Save" button might be grayed out after entering all the required field values.
This can be seen if "connection-url-pattern" value in the data source template is updated with the data source "Connection URL" value. For example, the data source template for snowflake data source is as below.
<jdbc-type-settings> <type-name>Snowflake</type-name> <driver>net.snowflake.client.jdbc.SnowflakeDriver</driver> <connection-url-pattern>jdbc:snowflake://<ACCOUNT>.snowflakecomputing.com</connection-url-pattern> <supports-catalogs>true</supports-catalogs> <supports-schemas>true</supports-schemas> <supports-procedures>false</supports-procedures> <fetch-size>10000</fetch-size> <batch-size>100</batch-size> <use-ansii-style-outer-join>true</use-ansii-style-outer-join> </jdbc-type-settings>
However, if the data source template is updated as below then the save button for Data source would be disabled, even after entering all the required details.
<jdbc-type-settings> <type-name>Snowflake</type-name> <driver>net.snowflake.client.jdbc.SnowflakeDriver</driver> <connection-url-pattern>jdbc:snowflake:test.snowflakecomputing.com</connection-url-pattern> <supports-catalogs>true</supports-catalogs> <supports-schemas>true</supports-schemas> <supports-procedures>false</supports-procedures> <fetch-size>10000</fetch-size> <batch-size>100</batch-size> <use-ansii-style-outer-join>true</use-ansii-style-outer-join> </jdbc-type-settings>
The connection URL for the data source " jdbc:snowflake:test.snowflakecomputing.com", should not be used in the "connection-url-pattern". Note that "Connection URL pattern" field defines what the format of the data source connection URL is, where as the "Connection URL" field defines the data source URL in that format.