Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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.