I have two identically structured datasets stored in different schemas. I am trying to create a workflow where...
view: view_one {
sql_table_name: {% parameter schema_name %}.view_one ;;
parameter: schema_name {
type: unquoted
allowed_value: {
label: "Dataset 1"
value: "dataset_one"
}
allowed_value: {
label: "Dataset 2"
value: "dataset_2"
}
}
}
view: view_two {
sql_table_name: {% parameter schema_name %}.view_two ;;
parameter: schema_name {
type: unquoted
allowed_value: {
label: "Dataset 1"
value: "dataset_one"
}
allowed_value: {
label: "Dataset 2"
value: "dataset_2"
}
}
}
explore: base_explore {
view_name: view_1
join: view_2 {
sql_on: {
type: inner
sql_on: ${view_one.id} = ${view_2.id};;
}
}
}
explore: dataset_1 {
extends: [base_explore]
always_filter: {
filters: [
view_one.schema_name: "Dataset 1",
view_two.schema_name: "Dataset 1",
]
}
}
explore: dataset_2 {
extends: [base_explore]
always_filter: {
filters: [
view_one.schema_name: "Dataset 2",
view_two.schema_name: "Dataset 2",
]
}
}
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |