Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current Restore this Version View Version History

« Previous Version 2 Current »

Notebook que tem como objetivo a criação de views no Databricks para serem consumidas pelo projeto.

  • Notebook: criacao_views_margin_analysis

  • Views finais: margin_analysis.vw_lfa1_fornecedores, margin_analysis.vw_knvv_clientes_vendas, margin_analysis.vw_kna1_clientes_geral, margin_analysis.vw_tvtwt_canal_distribuicao, margin_analysis.vw_t001w_centro, margin_analysis.vw_tgsbt_divisao, margin_analysis.vw_t001_empresa, margin_analysis.vw_tvgrt_equipe_vendas, margin_analysis.vw_tvkbt_escritorio_vendas, margin_analysis.vw_t137t_setor_industrial, margin_analysis.vw_tvv1t_grupo_cliente_1, margin_analysis.vw_tvv2t_grupo_cliente_2, margin_analysis.vw_tvv3t_grupo_cliente_3, margin_analysis.vw_tvv4t_grupo_cliente_4, margin_analysis.vw_tvv5t_grupo_cliente_5, margin_analysis.vw_t188t_grupo_preco, margin_analysis.vw_tpart_funcao_parceiro, margin_analysis.vw_tinct_incoterm, margin_analysis.vw_tvkot_organizacao_vendas, margin_analysis.vw_tspat_setor_atividade, margin_analysis.vw_t141t_status_material, margin_analysis.vw_tvakt_tipo_documento e margin_analysis.vw_t179t_hierarquia_material.

1. Origem

Maioria das views tem origem da database sap do Databricks e outras do processo do upload_temporario_dimensoes_sap, que cria algumas tabelas na database margin_analysis_temp.

2. Criação das Views

As views são selects de todos os campos e registros de suas respectivas tabelas de origem. São criadas na database margin_analysis.

%sql create or replace view margin_analysis.vw_lfa1_fornecedores as select * from sap.lfa1;
create or replace view margin_analysis.vw_knvv_clientes_vendas as select * from sap.knvv;
create or replace view margin_analysis.vw_kna1_clientes_geral as select * from sap.kna1;
create or replace view margin_analysis.vw_tvtwt_canal_distribuicao as select * from sap.tvtwt;
create or replace view margin_analysis.vw_t001w_centro as select * from sap.t001w;
create or replace view margin_analysis.vw_tgsbt_divisao as select * from margin_analysis_temp.tgsbt;
create or replace view margin_analysis.vw_t001_empresa as select * from margin_analysis_temp.t001;
create or replace view margin_analysis.vw_tvgrt_equipe_vendas as select * from sap.tvgrt;
create or replace view margin_analysis.vw_tvkbt_escritorio_vendas as select * from sap.tvkbt;
create or replace view margin_analysis.vw_t137t_setor_industrial as select * from margin_analysis_temp.t137t;
create or replace view margin_analysis.vw_tvv1t_grupo_cliente_1 as select * from margin_analysis_temp.tvv1t;
create or replace view margin_analysis.vw_tvv2t_grupo_cliente_2 as select * from margin_analysis_temp.tvv2t;
create or replace view margin_analysis.vw_tvv3t_grupo_cliente_3 as select * from margin_analysis_temp.tvv3t;
create or replace view margin_analysis.vw_tvv4t_grupo_cliente_4 as select * from margin_analysis_temp.tvv4t;
create or replace view margin_analysis.vw_tvv5t_grupo_cliente_5 as select * from margin_analysis_temp.tvv5t;
create or replace view margin_analysis.vw_t188t_grupo_preco as select * from sap.t188t;
create or replace view margin_analysis.vw_tpart_funcao_parceiro as select * from margin_analysis_temp.tpart;
create or replace view margin_analysis.vw_tinct_incoterm as select * from margin_analysis_temp.tinct;
create or replace view margin_analysis.vw_tvkot_organizacao_vendas as select * from margin_analysis_temp.tvkot;
create or replace view margin_analysis.vw_tspat_setor_atividade as select * from sap.tspat;
create or replace view margin_analysis.vw_t141t_status_material as select * from sap.t141t;
create or replace view margin_analysis.vw_tvakt_tipo_documento as select * from sap.tvakt;
create or replace view margin_analysis.vw_t179t_hierarquia_material as select * from sap.t179t;