If multiple applications are hosted on the same Appian platform, and I want to create a separate schema in the Appian Cloud database for each application's tables, how should I reference a specific table within a specific schema when creating a Data Store in Appian? I initially tried querying using schema_name.table_name, but it didn’t work as expected. However, when I ran SHOW TABLES FROM <schema_name>, I was able to see the tables listed under that schema, which confirms that the schema and its tables are accessible.
schema_name.table_name
SHOW TABLES FROM <schema_name>
Discussion posts and replies are publicly visible
sanjuktab2257 said:I want to create a separate schema in the Appian Cloud database for each application's tables, how should I reference a specific table within a specific schema when creating a Data Store in Appian?
If your data source has access to multiple schemas, you can create a CDT mapped to a table from any accessible schema, and Appian will let you add that table as an entity in the Data Store. However, you must ensure your connection settings and DB user have permissions for all schemas you want to access; otherwise, only the default schema will be available for selection.