When running a function or trying to access a table/view, you may encounter the following error message:
Object __ does not exist or not authorized.
The reason for that is you simply need access to the function or the table. Please review the dataset you have access to first. Your acquired/trial dataset has a defined and specific UDF and table/view. However, the Snowflake marketplace data exchange requires us to send you all our tables and functions and then selectively give you access to resources (VIEW and Functions) based on your purchased dataset.
From the dataset you have purchased, you have access to the following:
- Your dataset VIEW
- Your dataset assigned UDTF
- General Purpose UDFs
- All our sample dataset views
For example, if you have purchased the IP geolocation dataset, you have access to the following:
- Dataset VIEW:
IP_GEOLOCATION - UDTF:
IP_LOCATION - Samples of all our existing dataset products
- General Purpose UDFs such as
RANGE_TO_CIDR,RAND_IP,COUNT_IPetc.
If you try to access a table or function not granted access by the dataset you have purchased, you will get the table/function that does not exist or an authorized error. Another reason why this error may appear is simply because you have made a typo.
To verify which dataset (VIEW) and functions (UDTF) you have access to, head down to the “Views, UDTFs and Database Names” section of the documentation. There, you will see the resources you have been assigned upon purchasing the dataset.