DB Extractor: Multiple query execution via single .ymal file

Hi,
The DB extractor allows for running many queries, did you have a look at the logs ? Maybe there is something wrong with the first queries ? (setting your logger to DEBUG will probably give you more insights)

Hi @Pierre Pernot ,

I’m keeping the destination of both queries as some. Even setting the logger to DEBUG, I’m unable to get any other information.

 

Hi @Prashant Chauhan, just wondering if you were able to sort out your issue?

Hi @Carin Meems ,

I’m still unable to resolve this.
Only the last-mentioned query is getting executed.

Hi,
In the configuration file you shared, I can’t see any dash ( “-” ). Can you please add a dash in front of each “name” argument ? 

In a YAML file, each list element must start with a dash. (https://docs.ansible.com/ansible/latest/reference_appendices/YAMLSyntax.html

queries:
  - name: query_one
    database: postgres
    query: >
      SELECT * FROM ITEM_PROPERTY WHERE PROPERTY_TYPE = "NAME"
    destination:
      database: "query_multiple"
      table: "raw_one"
    primary-key: "{ITEM_ID}-{PROPERTY_STRING}"
  - name: query_two
    database: postgres
    query: >
      SELECT * FROM ITEM_PROPERTY WHERE PROPERTY_TYPE = "PRODUCT"
    destination:
      database: "query_multiple"
      table: "raw_one"
    primary-key: "{ITEM_ID}-{PROPERTY_STRING}"

Please try and let us know.

Pierre

Hi @Pierre Pernot,

Thanks for your help.