BookmarkSubscribeRSS Feed
PhatRam33
Fluorite | Level 6

Anyone seen this error before?  Trying to make sense of this and folks I have spoken to have not been able to figure out so far.  Attempting to connect to GCP through a linux server.  Work on other projects except for my billing project.

 

ERROR: CLI error trying to establish connection: Optional feature not
implemented : Invalid native catalog name occurs in mappings:
DB=anbc-hcb-dev. : No data source or driver specified; dialog prohibited
TKTS_ATTR_CURRENT_CATALOG

 

Trying to connect to my billing project using libname statement and in order to upload data and no luck.

 

*establish connection to linux;
%let sasapp = xmeuw01p.xxxxx.com 7551;
options comamid=tcp;
signon SASApp &_log_inf;
*submit code to linux for bigquery access;
rsubmit sasapp;
%put Remote environment: &syshostname;
libname db bigquery project="xxxxxx"
credfile="/xy/testsasgcp/sasgcp.json"
schema="xxxxxx" Bulkload=yes MAX_CHAR_LEN=50;
endrsubmit;
signoff;

 

 

2 REPLIES 2
SASKiwi
PROC Star

Has a connection to this particular database ever worked or are you trying it for the first time? Does removing the BULKLOAD option help? If connections to other GBQ databases work then that suggests a database configuration problem.

rohitshetty1
Calcite | Level 5

This is likely a permission issue. The service account used in the credentials file does not have access to the billing project which is throwing this completely weird error, that is nothing to do with permissions. 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1881 views
  • 1 like
  • 3 in conversation