Best Practices When You Connect to CockroachDB

CockroachDB is a cloud-based data source that is compatible with a PostgreSQL LIBNAME connection. When you connect to CockroachDB, be aware of the following differences in behavior from a standard connection to PostgreSQL:

• The best practice when you connect to CockroachDB is to use the default SHAREDREAD value for the CONNECTION= LIBNAME option. Setting CONNECTION=SHARED is not fully supported, although you can use this value for Read operations. CREATE or DROP operations are not supported when you set CONNECTION=SHARED.
• It is recommended that you limit table names and column names to 128 bytes. CockroachDB documentation states that this name limit might be enforced in future updates. Also, accessing table or columns names longer than 128 bytes is not currently supported for PROC FEDSQL.
• When you use NLS data on CockroachDB, the best practice is to use the UTF-8 SAS session encoding.