Image
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
Image Image Databases
 Create Database Catalogs
Image Image Catalog
 Drop Database, Rename Database Database Parameters
Image Image Schemas
 Create Schema Schemas
Image Image Schema
 Export Schema[1], Drop Schema, Rename Schema Info
Image Image Tables
 Create Table[1], Import Table Data[1] References, Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Dynamic Tables
   Tables
Image Image Dynamic Table
 Drop Dynamic Table, Refresh Dynamic Table, Rename Dynamic Table Data, Columns, Info, Native DDL, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Event Tables
   Tables
Image Image Event Table
 Drop Event Table, Rename Event Table Data, Columns, Info, Native DDL, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Hybrid Tables
   Tables
Image Image Hybrid Table
 Drop Hybrid Table, Rename Hybrid Table Data, Columns, Info, Native DDL, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image External Tables
   External Tables
Image Image External Table
   External Tables
Image Image Iceberg Tables
   Iceberg Tables
Image Image Iceberg Table
   Iceberg Tables
Image Image Views
   Views
Image Image View
 Export View[1], Script: Script View, Drop View, Rename View Columns, DDL[1], Data, Info, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Materialized Views
   Materialized Views
Image Image Materialized View
 Script: Script Materialized View, Drop Materialized View Data, Columns, Info, Native DDL, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Sequences
 Create Sequence Sequences
Image Image Sequence
 Drop Sequence, Rename Sequence Info
Image Image Stored Procedures
 Create Procedure Procedures
Image Image Procedure
 Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure, Rename Procedure Procedure Editor[1], Interface
Image Image Functions
 Create Function Functions
Image Image Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Interface
Image Image File Formats
   FileFormats
Image Image File Format
   FileFormat
Image Image Stages
   Stages
Image Image Stage
   Stage
Image Image Pipes
   Pipes
Image Image Pipe
   Pipe
Image Image Streams
   Streams
Image Image Stream
 Drop Stream Stream
Image Image Tasks
   Tasks
Image Image Task
 Drop Task Task
Image Image Alerts
   Alerts
Image Image Alert
   Alert
Image Image DBA Views
   DBA
Image Image Server Info
   Account Parameters, Session Parameters
Image Image Users
 Create User[2] Users, Users[2]
Image Image User[2]
 Abort all queries, Disable/Enable User, Drop User, Rename User Describe, Info, Last Queries, Login Attempts, User Parameters
Image Image Roles
 Create Role[2] Enabled Roles, Roles
Image Image Role
 Drop Role[2] Info, Role grants
Image Image Warehouses
 Create Warehouse Metering history 10 days, Warehouses
Image Image Warehouse
 Drop Warehouse, Resume/Suspend Info, Warehouse Parameters
Image Image Locks
   Locks
Image Image Query History
   Last Queries
[1] DbVisualizer Pro
[2] Requires the SECURITY_ADMIN role