0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

SnowflakeのNotebookをどこのDB.SCHEMAに作成したか忘れたときに確認する方法

Posted at

このNotebook、どこのスキーマに作ったっけ?って作成した翌日以降によく起こるのでメモ。

python コード
session = get_active_session()
session
sql
SHOW schemas;
-- is_current カラムが'Y'のスキーマが現在地

GUIで確認したいので、何か方法ありますか?とSnowVillageで聞いたら教えてもらえました。ありがとうございます。

左のNotebook名の...からCopy full path で確認する。

image.png

左メニューのProjects-Notebooksを選んだときに、右の一覧にLOCATIONがでてくる

(Home選択時にはでてこない)
image.png

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?