Sha256: be3ddf0fee58dd5d85085cf7e9d4aa4e487c65e0dca76b8c1132d8d23e0cd1f9
Contents?: true
Size: 903 Bytes
Versions: 4
Compression:
Stored size: 903 Bytes
Contents
with
source as (
select * from {{ source('<%= sql.source_name %>', '<%= sql.table_name %>') }}
),
renamed as (
select
<%- sql.select_column_names.each_with_index do |(column_type, columns), column_type_index| -%>
-- <%= column_type %>
<%- columns.each_with_index do |column, column_index| -%>
<%- is_rename_primary_id = sql.primary_key_eql_id? && sql.primary_key?(column.name) -%>
<%- is_last_column = column_type_index == sql.select_column_names.size - 1 && column_index == columns.size - 1 -%>
<%= is_rename_primary_id ? "id as #{sql.rename_primary_id}" : column.name %><% unless is_last_column -%>,<%- end %>
<%- if column_type_index != sql.select_column_names.size - 1 && column_index == columns.size - 1 -%>
<%- end -%>
<%- end -%>
<%- end -%>
from source
)
select * from renamed
Version data entries
4 entries across 4 versions & 1 rubygems