how to construct a snapgpt prompt for pipeline generation
Here's a comprehensive guide on how to construct effective SnapGPT prompts for pipeline generation: --- ๐ง How to Construct a SnapGPT Prompt for Pipeline Generation โ Core Principles (The 3 C's) | Principle | Description | |-----------|-------------| | Clear | Be precise so SnapGPT can determine the most suitable response | | Concise | Be brief to reduce response latency | | Consistent | Be consistent to avoid variability in results | --- ๐ Prompt Structure Best Practices A well-constructed prompt should include: 1. Action โ What you want to do (e.g., read, write, transform, join) 2. Source System โ Where the data comes from (e.g., Salesforce, AWS S3, REST API) 3. Target System โ Where the data should go (e.g., Snowflake, Google BigQuery, a file) 4. Data/Object โ What data is involved (e.g., Opportunities, CSV file, customer records) 5. Conditions (optional) โ Any filtering, routing, or transformation logic --- ๐ Prompt Quality Examples
Good: Generate a pipeline to move data to S3.
Better: Generate a pipeline to move Salesforce data to an S3 bucket.
Best: Generate a pipeline to read Salesforce Opportunity records
and write them to an S3 bucket in JSON format.
--- ๐ก Example Prompts That Work Well - Create a SnapLogic pipeline to join tables t1 and t2 and insert the output into table t3. - Read a file in CSV format and write to Google Sheets. - Get Salesforce opportunities and write to BigQuery. - Generate a pipeline with a JSON Generator that contains 10 sample Salesforce lead objects. - Get exchange rates from the European Central Bank and write the output to a JSON file. - Use an API to compute carbon emissions based on 50 kWh electricity consumption in FL, USA. - Download a CSV file from S3 and query it for records with zip code 78660. --- ๐ซ What to Avoid - โ Vague prompts โ e.g., "Generate a pipeline" (no context) - โ General/off-topic questions โ e.g., "What is the capital of Florida?" - โ Sensitive data โ Never include credentials, passwords, or PII in your prompt --- ๐ ๏ธ How to Use the Pipeline Generation Skill 1. Open SnapGPT from the Designer tab 2. Click Pipeline generation from the Featured Skills 3. Replace the example prompt with your specific use case 4. Use Extended Thinking mode for best accuracy in pipeline generation 5. Hit Return or click the submit button 6. Review the generated pipeline preview and choose to: - Replace the current pipeline, or - Import it into a new tab --- ๐ธ Pro Tip: Generate from an Image! You can also upload a flow diagram (.jpg, .jpeg, or .png, max 750 KB) to visually describe your pipeline. SnapGPT will interpret the diagram and generate the corresponding pipeline automatically. --- By following these guidelines, you'll get the most accurate and useful pipeline generations from SnapGPT! ๐
