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
Databases
 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
Dynamic Tables
   Tables
Dynamic Table
 Drop Dynamic Table, Refresh Dynamic Table, Rename Dynamic Table Data, Columns, Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
Event Tables
   Tables
Event Table
 Drop Event Table, Rename Event Table Data, Columns, Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
Hybrid Tables
   Tables
Hybrid Table
 Drop Hybrid Table, Rename Hybrid Table Data, Columns, Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
External Tables
   External Tables
External Table
   External Tables
Iceberg Tables
   Iceberg Tables
Iceberg Table
   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
Materialized Views
   Materialized Views
Materialized View
 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
Stored 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
File Formats
   FileFormats
File Format
   FileFormat
Stages
   Stages
Stage
   Stage
Pipes
   Pipes
Pipe
   Pipe
Streams
   Streams
Stream
   Stream
Tasks
   Tasks
Task
   Task
Alerts
   Alerts
Alert
   Alert
DBA Views
   DBA
Server Info
   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
Query History
   Last Queries
[1] DbVisualizer Pro
[2] Requires the SECURITY_ADMIN role