import great_expectations as ge
from great_expectations.core.batch import BatchRequest

context = ge.data_context.DataContext()
suite = context.create_expectation_suite(
    "sf_temp_table", overwrite_existing=True # Configure these parameters for your needs
)

batch_request = BatchRequest(
    datasource_name="snowflake_datasource",
    data_connector_name="default_runtime_data_connector_name",
    data_asset_name="TEMP_TABLE"
)
validator = context.get_validator(batch_request=batch_request, expectation_suite=suite)

# Start creating Expectations here
validator.expect_column_values_to_not_be_null('AGREEMENT_ID')

...

# And save the final state to JSON
validator.save_expectation_suite(discard_failed_expectations=False)