Allows identification of tables and views with the specified qualifier.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Access |
| Alias: | CATEGORY= [Google BigQuery] |
| Default: | none |
| Data source: | Amazon Redshift, Google BigQuery, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, PostgreSQL, Vertica |
| See: | QUALIFIER= data set option |
| Example: | In a LIBNAME statement:
|
Table of Contents
If you omit this option, the default is the default DBMS qualifier name, if any. You can use QUALIFIER= for any DBMS that allows three-part identifier names, such as qualifier.schema.object.
Google BigQuery: Specify the qualifier in single or double quotation marks. QUALIFIER= is typically the catalog name, not the native project ID. If you are accessing files in the default login project, do not specify a catalog or specify the qualifier to match the libref value. (See the Google BigQuery example below.)
Microsoft SQL Server: The Microsoft SQL Server interface supports three-part table names, in the structure qualifier.schema.table. It is possible to specify a value for QUALIFIER= and not for SCHEMA=. In this case, a table would be specified as qualifier..table in the SQL code that is passed to the database.
MySQL: The MySQL interface does not support three-part identifier names, so a two-part name is used (such as qualifier.object).
In this LIBNAME statement, the QUALIFIER= option causes ODBC to interpret any reference to Mydblib.Employee in SAS as Mydept.Scott.Employee.
libname mydblib odbc dsn=myoracle
password=testpass schema=scott
qualifier=mydept;In this example, the QUALIFIER= option causes OLE DB to interpret any reference in SAS to Mydblib.Employee as Pcdivision.Raoul.Employee.
libname mydblib oledb provider=SQLOLEDB
properties=("user id"=dbajorge "data source"=SQLSERVR)
schema=raoul qualifier=pcdivision;
proc print data=mydblib.employee;
run;For Google BigQuery, if you are accessing files in the default login project, do not specify a catalog or specify the qualifier to match the libref value. In this example, the QUALIFIER= value matches the libref value ‘gbq’:
libname gbq bigquery project='sas-plt'
qualifier='gbq'
schema='sample';