Snowflake

Snowflake object type support.

The following table shows the database specific support in DbVisualizer for Snowflake organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object Type Actions Viewers
Catalogs
Create Database Catalogs
Catalog
Drop Database, Rename Database Database Parameters
Schemas
Create Schema Schemas
Schema
Export Schema[1], Drop Schema, Rename Schema Info
Tables
Create Table[1], Import Table Data[1] References, Tables
Table
Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Drop Table, Empty Table, Rename Table Navigator[1], References, Data, Columns, DDL[1], Grants, Info, Primary Key, Row Count
Columns
  Columns
Column
  Column
DynamicTables
  Tables
DynamicTable
Drop Dynamic Table, Refresh Dynamic Table, Rename Dynamic Table Data, Columns, Info, Native DDL, Row Count
Columns
  Columns
Column
  Column
EventTables
  Tables
EventTable
Drop Event Table, Rename Event Table Data, Columns, Info, Native DDL, Row Count
Columns
  Columns
Column
  Column
HybridTables
  Tables
HybridTable
Drop Hybrid Table, Rename Hybrid Table Data, Columns, Info, Native DDL, Row Count
Columns
  Columns
Column
  Column
ExternalTables
  External Tables
ExternalTable
  External Tables
IcebergTables
  Iceberg Tables
IcebergTable
  Iceberg Tables
Views
  Views
View
Export View[1], Script: Script View, Drop View, Rename View Columns, DDL[1], Data, Info, Row Count
Columns
  Columns
Column
  Column
MaterializedViews
  Materialized Views
MaterializedView
Script: Script Materialized View, Drop Materialized View Data, Columns, Info, Native DDL, Row Count
Columns
  Columns
Column
  Column
Sequences
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence Info
Procedures
Create Procedure Procedures
Procedure
Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure, Rename Procedure Procedure Editor[1], Interface
Functions
Create Function Functions
Function
Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Interface
FileFormats
  FileFormats
FileFormat
  FileFormat
Stages
  Stages
Stage
  Stage
Pipes
  Pipes
Pipe
  Pipe
DBA
  DBA
ServerInfo
  Account Parameters, Session Parameters
Users
Create User[2] Users, Users[2]
User[2]
Abort all queries, Disable/Enable User, Drop User, Rename User Describe, Info, Last Queries, Login Attempts, User Parameters
Roles
Create Role[2] Enabled Roles, Roles
Role
Drop Role[2] Info, Role grants
Warehouses
Create Warehouse Metering history 10 days, Warehouses
Warehouse
Drop Warehouse, Resume/Suspend Info, Warehouse Parameters
Locks
  Locks
QueryHistory
  Last Queries
[1] DbVisualizer Pro
[2] Requires the SECURITY_ADMIN role
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗