Skip to content

database_alias on mssql #4449

@datatimnih

Description

@datatimnih

Describe the bug
i'm trying to ingest my mssql to datahub with this config

source:
  type: mssql
  config:
    uname,pas,port
    database: db_name
    database_alias: db_alias

but doesn't use the database_alias like db_alias.dbo.table its still using the database name db_name.dbo.table

To Reproduce
Steps to reproduce the behavior:

  1. creating the mssql config file with databse_alias
  2. idatahub -c ingest config_file.yml
  3. see on the datahub its stil using the original database name

Expected behavior
expected result: db_alias.dbo.table (using database_alias from config file)
actual result: db_name.dbo.table (ignoring the database_alias)

Additional context
after following some instruction from slack forum to add code similar tothis after this line.
its still using db_name and still ignoring the db_alias in the config file.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugBug report

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions