Hello, I am trying to ingest data from Microsoft A...
# ingestion
g
Hello, I am trying to ingest data from Microsoft Azure SQL Server and receiving the following error. File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\datahub\entrypoints.py", line 91, in main sys.exit(datahub(standalone_mode=False, **kwargs)) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\click\core.py", line 1137, in call return self.main(*args, **kwargs) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\click\core.py", line 1062, in main rv = self.invoke(ctx) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\click\core.py", line 1668, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\click\core.py", line 1668, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\click\core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\click\core.py", line 763, in invoke return __callback(*args, **kwargs) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\datahub\cli\ingest_cli.py", line 48, in run pipeline_config = load_config_file(config_file) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\datahub\configuration\config_loader.py", line 35, in load_config_file config = config_mech.load_config(config_fp) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\datahub\configuration\yaml.py", line 12, in load_config config = yaml.safe_load(config_fp) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\__init__.py", line 162, in safe_load return load(stream, SafeLoader) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\__init__.py", line 114, in load return loader.get_single_data() File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\constructor.py", line 49, in get_single_data node = self.get_single_node() File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\composer.py", line 36, in get_single_node document = self.compose_document() File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\composer.py", line 55, in compose_document node = self.compose_node(None, None) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\composer.py", line 84, in compose_node node = self.compose_mapping_node(anchor) File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\composer.py", line 127, in compose_mapping_node while not self.check_event(MappingEndEvent): File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\parser.py", line 98, in check_event self.current_event = self.state() File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\parser.py", line 428, in parse_block_mapping_key if self.check_token(KeyToken): File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\scanner.py", line 116, in check_token self.fetch_more_tokens() File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\scanner.py", line 223, in fetch_more_tokens return self.fetch_value() File "C:\Users\v-akshaya\AppData\Local\Programs\Python\Python39\lib\site-packages\yaml\scanner.py", line 577, in fetch_value raise ScannerError(None, None, ScannerError: mapping values are not allowed here in "<file>", line 3, column 9
s
you should post your ingestion file with credentials redacted. Without that no one will be able to help
g
source: type:mssql config: host_port: "host_port:1433" env: "DEV" database: database #Credentials username: username password: password sink: type: "datahub-rest" config: server: "http://localhost:8080"