This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation

Oracle execute with setting session variables

I would like to set date format and timestamp format for the session and run the select statement in oracle execute snap like this Begin execute immediate ‘alter session set nls_date_format=’‘MM/DD/YYYY’‘’; execute immediate ‘alter session set nls_ti...

GV2019 by • New Contributor II
  • 1674 Views
  • 0 replies
  • 0 kudos

Oracle dimension tables to Azure ADLS

We’re starting a project to move dozens of Oracle warehouse dimension tables to ADLS, and are using parent/child pipelines to pass table names. The pipelines correctly pass and resolve the table name to operate on. The child pipeline uses Oracle E...

Resolved! Oracle Table Partition Name as parameter

I have a child pipeline called from Pipeline Execute which is passing partition name as pipeline parameter to Oracle-Execute snap Oracle-Execute has a sql => “select * from obia1.sales_invoice_lines partition (” + _partName + “) where rownum < 11” th...

GV2019 by • New Contributor II
  • 3340 Views
  • 2 replies
  • 1 kudos

Object mapping

I have a situation in which for one object I can have more than one node which has the same name. However, each node may be different by additional attributes "IsUpdated, “IsAdded”. It is also possible that the node doesn’t have any attentional attri...

Creating output file names dynamically for each SQL Server table data stream taken as input from configuration File

I am trying to create a pipeline which will take a configuration file as an input and it will have Table name and column names that i will need for that table. You can put any no of tables and for each table no of column selected will be different. I...

Resolved! Snaplogic Pipeline Metadata

Hi , I am trying to read the pipeline metadata, specifically the child pipeline names that are invoked from a particular pipeline . I used the Snaplogic Read snap and i have the information in the $snap_map object variable , inside which there are su...

Preeta by • New Contributor II
  • 3788 Views
  • 4 replies
  • 0 kudos
SnapLogic Trust Site
Visit Trust.SnapLogic.com for real-time visibility into system performance and availability.
SnapLogic Documentation
Visit our documentation for detailed information on functionality and features.
  • New site
  • Original documentation site
    • New solutions
    Find More Solutions