Snowflake Tested for version 3.56+
Overview JDBC Drivers Features Supported Objects Download

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 TypeActionsViewers
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 ↗