The tricky part is remembering to include the schema name.
Code: Select all
LIBNAME <VerticaLibaryName> DATASRC='<ODBCDataSourceName' USER='<UserName>' PASSWORD='<Password>' SCHEMA='<SchemaName>';
Code: Select all
LIBNAME EDW DATASRC='ODBC_EDW' USER='MyNameHere' PASSWORD='MyPasswordHere' SCHEMA='public';