liveBook · Manning

Production

As explained in Snowflake Data Engineering

A production environment is the environment in which an approved system runs for its intended users and operational workloads.

A production environment is where approved data pipelines execute on live data and provide the required data structures for downstream consumers. It is configured for performance, reliability, and security, making it the operational destination after development and testing. section 15.1

Place production within the delivery pipeline:

  • Developers build prototypes, compare approaches, and optimize pipeline code in development. section 15.1
  • Test and quality assurance teams verify pipeline functionality, performance, and reliability before release. section 15.1
  • Business users may validate functionality, data correctness, completeness, and governance in a user acceptance test environment. section 15.1
  • Continuous delivery automates deployment between these environments, while continuous integration runs automated actions after code changes merge into the repository. section 15.0

Pipeline release

A bakery data pipeline ingests operational-system data and customer order JSON files, transforms the data, and moves through development and testing before executing in production for downstream consumers. section 15.0 section 15.1

Table 15.1 Types of data testing and the data they require
Test type
Data requirements
Data pipeline functionality
Small data sample
Data pipeline performance
Data volume similar to the production data volume
Data integrity
Data that closely resembles the data from the production environment
Data governance features
When production data contains sensitive information that should not be shared in the development and test environments, generated data or masked data can be used for testing.

Use testing data that matches the production workload: small samples for functionality, production-scale volumes for performance, representative data for integrity, and masked or generated data for sensitive governance tests. section 15.1

How Snowflake Data Engineering covers it

How deep it goes
Defines production responsibilities and environment progression, but stops short of detailed deployment commands or configuration procedures.
Examples
Uses a bakery pipeline ingesting operational data and JSON orders, with testing based on representative volumes, integrity, and governance needs.
What it assumes
Assumes familiarity with data pipelines and downstream consumers, while distinguishing development, testing, and acceptance environments.
What you can do after
Operate pipelines for live workloads while separating development, testing, acceptance, and release activities.
How it connects
Connects development environments, test environments, user acceptance testing, continuous integration, and continuous delivery.

Also explained in

Compare how 8 books explain production →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Snowflake Data Engineering. The section links point to the parts of the book it draws on.