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!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...