This message was deleted.
# secoda-support
w
This message was deleted.
e
@abundant-crowd-2724 do you have any insight on this? I know you’ve played around with the permissions in Snowflake more than I have. If not I can take a look into this. Just wanted to check first.
a
Thanks Andrew! In a nut shell, I just want to know whether i need to explicitly grant access to every database we have or if there's just a simple catch all command I can run. We also use blue-green deploy so I'm not sure how the lineage might work in this case, but ideally we don't need to grant access to the staging db in a blue-green deploy
Any ideas on this @abundant-crowd-2724?
e
I’ll look into this this morning for you @agreeable-fish-22746
a
Thanks!!
e
@agreeable-fish-22746 based on the research it looks like the query you’ve pasted above would do the trick. You just have to associate
ROLE
with the user you connect to Secoda with.
a
gotcha, I'll try that now and let you know if I run into any issues! Would make it a lot simpler for future Snowflake users to onbaord as well IMO!
@elegant-house-93198 so it looks like it's only pulling in the schemas within the default
SNOWFLAKE
database. i.e.
account_usage
organization_usage
,etc. And not actually extracting the production databases that can be derived from this DB
e
@agreeable-fish-22746 let me make a quick update to our Snowflake queries to make it so that works properly. It shouldn’t take too long and you’re right that it will make things easier for future users. I’ll let you know when it’s been completed. Hopefully in the next hour
💯 1
a
Thanks! For now I've explicitly created a Snowflake integration for each database we plan to sync
We have a bunch of interim tables that Airbyte uses to build source tables, is there a way to deselect and not sync all of these tables?
e
Yes, if you go to the Integration in Secoda and then the Schema tab you can select which schemas and associated tables come into Secoda.
a
Doesnt let me expand to see the tables
e
If you want we can update that UI to also include tables?
a
Yes that would be great - we have many
_scd
suffixed tables that Airbyte uses for incremental syncs and a lot of
_airbyte
prefixed tables (that I can't seem to search for in the search bar) that shouldnt be included. In the image below I've searched for
_airbyte_
it's saying there are 722 results but only shows 2 pages of them, none of which are the airbyte prefixed tables
e
For the screenshot, are those the results after searching
_airbyte
? It would be good to get a full screenshot if possible to get a better understanding of what’s going on.
a
Yup, those are the results after entering
_airbyte
in the searchbar
e
That’s helpful, should be a quick fix on our end. I’ll let you know when it’s been fixed.
a
Awesome, just adding on, similarly if I search for
core.
it would display 143 results on the right but only 10ish in the list with no pages to select
e
I’ve also forwarded this to our engineering team. A solution while you’re waiting on the fix is to select the “Tables” option on the right side. That should show all the tables.
👍 1
The “All” bug should be fixed now. Let me know if you continue to experience the issue with it.
👍 1
a
Hey Andrew is this available yet? I've got probably around 600 tables that are temp tables I don't want to include in any of the searches or catalogs https://secodacommunity.slack.com/archives/C01PT4WP0TE/p1644257802323409?thread_ts=1643998298.824089&cid=C01PT4WP0TE
e
It’s not available yet, some additional work came up today. But I still have it on the top of my todo list so hoping to get to it tomorrow morning.
👍 1