Gilberto Hernandez - Build & deploy a Snowflake Native Application using Python | PyData Global 2023

Build and deploy a Snowflake Native Application using Python with Gilberto Hernandez, exploring the framework, primitives, and features that enable seamless data integration and customization.

Key takeaways
  • The Snowflake native app framework is similar to using Flexbox and divs to create a grid.
  • The framework provides a way to build and deploy Snowflake native applications using Python.
  • The application package is a type of database that contains the application code and schema.
  • The native app framework uses Snowflake primitives such as warehouses, schemas, and tables.
  • The application package can be deployed to Snowflake accounts in an organization.
  • The framework allows for the creation of a custom API using Flask and connecting to Snowflake using Snowpark for Python.
  • The application can be deployed using the Snowflake CLI or VS Code extension.
  • The framework provides permissions and privileges for the application to access data and resources.
  • The application can be distributed to multiple accounts in an organization using Snowflake’s marketplace.
  • The framework provides a quickstart package to get started with building a Snowflake native application.
  • The application can be used to ingest data from multiple sources using the Snowpark for Python library.
  • The framework provides a way to map tables and columns between the application and Snowflake schema.
  • The application can be used to create custom SQL functions and UDFs using Snowpark for Python.
  • The framework provides a way to grant reference access to tables and procedures for the application.
  • The application can be used to create custom APIs and expose data to consumers.
  • The framework provides a way to distribute the application to multiple accounts in an organization.
  • The application can be used to monitor and debug issues using Snowflake’s logging and tracing features.
  • The framework provides a way to create custom workflows and data pipelines using Snowpark for Python.