Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
856 views
in Technique[技术] by (71.8m points)

jdbc - Splunk not showing all databases from Snowflake

I have successfully made connection between splunk and snowflake and able to get test db data from snowflake to splunk. But Splunk is not showing all the databases from snowflake.

Below is the script which I used in Snowflake to create a new user, role and warehouse.

USE ROLE SECURITYADMIN;
CREATE OR REPLACE ROLE first_role;

USE ROLE SYSADMIN;
CREATE OR REPLACE warehouse first_wh
  warehouse_size = 'SMALL' 
  auto_suspend = 5
  auto_resume = true
  initially_suspended = true
  comment = 'SPLUNK ONLY NVIDIA' ;

GRANT USAGE, OPERATE on warehouse first_wh to role first_role;


USE ROLE SECURITYADMIN;
CREATE OR REPLACE USER first_user
   password = 'some password' 
   must_change_password = false
   default_warehouse = first_wh
   default_role = first_role
;

GRANT ALL PRIVILEGES on database NVIDIA_DB to ROLE first_role;
GRANT ROLE first_role TO USER first_user;

As you can see from the above script that I have created a user (first_user), role (first_role) and a warehouse (first_wh) and have provides ALL privledges.

At splunk I have configured the identities and connections as below.

Splunk Connection Splunk Identity

But when I go to splunk db connect Input to fetch data it doesnt show me the NVIDIA_DB. Here is the screenshot. Any idea how to resolve it or what I am doing wrong here? Thanks

Splunk Input Page

question from:https://stackoverflow.com/questions/65904688/splunk-not-showing-all-databases-from-snowflake

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

So I figured out what was wrong, you have to specifically give rights to each table that you want to access from splunk. go to snowflake > databases > desired table > click on the table > on the right side there is windows which shows grant option > click there and grant rights to this tables.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...