Getting Data In

Is there a way to index Avro files in Splunk?

djain
Path Finder

Hi Splunkers,

I am in an odd pickle here.

So, I am ingesting data from Amazon Web Services (AWS) to my Splunk instance. I am able to see the data flowing in but the data is encrypted .avro, which from my knowledge, does not work with Splunk. Is there an add on or another way to decrypt and index these Avro files like JSON?

I apologize in advance if this question feels repetitive. I didn't find another answer for it.

Tags (4)
0 Karma

hramos_splunk
Splunk Employee
Splunk Employee

There is not an add-on that can natively ingest Avro files. Splunk is not able to read it because .avro files are in a binary format that Splunk can't read.

Alternatively, you can change the format to a text format prior to ingestion in order for Splunk to read it. For more information in this approach please check the answers post link below:

https://answers.splunk.com/answers/83891/indexing-an-avro-file.html

The example made is as follow:

Avro to “json” conversion:

Install Avro Tools:

wget 'https://archive.apache.org/dist/avro/avro-1.7.5/py/avro-1.7.5.tar.gz'
tar xvf avro-1.7.6.tar.gz
cd avro-1.7.6
sudo python setup.py (https://setup.py/) install

Install Avro Tools using PIP:

pip install avro

Conversion from Avro to json

avro cat "/avro_file_path/*.avro" -- format json >"output_file_path/output.json"

Data input >> Files & Directories >> Moniter "output_file_path/output.json"

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...